﻿CREATE PROCEDURE [dbo].[proc_Finance_Bank_GetList_TypeId]
	(
		@CompanyId int,
		@TypeId int
	)
AS
begin
	Select 
	Id,
	BId,
	TypeId,
	IsNull((Select Title From Finance_Bank_Type Where Id=Finance_Bank.TypeId),'...') As BankType,
	InitialMoney,
	CompanyId,
	IsNull((Select CompanyName From Company Where Id=Finance_Bank.CompanyId),'...') As Company,
	OpenBank,
	AccountName,
	AccountCartId,
	CreateDate,
	UserName
	From Finance_Bank Where CompanyId=@CompanyId and TypeId=@TypeId Order by Sort
end
	RETURN
